package com.mapper;

import com.bean.Goods;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

    @Mapper
public interface GoodsMapper {
        List<Goods> queryGoods();

        List<Goods> queryGoodsByNmae(String var1);

        int updateGoodsById(Goods var1);

        @Insert({"insert into goods(goodsname,goodstype,goodssub,price,jpgurl) values(#{goodsname},#{goodstype},#{goodssub},#{price},#{jpgurl})"})
        int addGoods(Goods var1);

        @Delete({"delete from goods where id=#{id}"})
        int deleteGoods(int var1);
    }

